USE [BMIG_MENSUAL_POST_CADENA]
GO

IF EXISTS (SELECT name FROM sysobjects WHERE name = N'WASP_M0008_CREATB_AS_CABECERA_ANU' AND type = 'P')
  DROP PROCEDURE WASP_M0008_CREATB_AS_CABECERA_ANU

GO
CREATE PROCEDURE WASP_M0008_CREATB_AS_CABECERA_ANU
AS

IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N'[DBO].[AS_CABECERA_ANULACIONES]') AND OBJECTPROPERTY(ID, N'ISUSERTABLE') = 1)
  DROP TABLE [DBO].[AS_CABECERA_ANULACIONES]


CREATE TABLE [DBO].[AS_CABECERA_ANULACIONES] (
  [TIPOREGISTRO] [VARCHAR] (1) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL ,
  [FECHAPROCESO] [VARCHAR] (8) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL ,
  [CANTREGANUL] [VARCHAR] (6) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL ,
  [TOTALPRIMANETA] [VARCHAR](14) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL ,
  [TOTALPRIMABRUTA] [VARCHAR](14) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL ,
  [FILLER] [VARCHAR] (109) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL 
) ON [PRIMARY]
